package com.platform;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * 名称：UpdatePassWord <br> 描述：批量更新密码<br> 注意事项：执行此类会把所有的用户(SYS_USER)密码初始化为a111111
 *
 * @author 李鹏军
 * @version 1.0
 * @since 1.0.0
 */
public class MysqlTest {

  /**
   * 数据库url
   */
  private static final String URL = "jdbc:mysql://localhost:3306/platform";
  /**
   * 用户名
   */
  private static final String USER = "root";
  /**
   * 密码
   */
  private static final String PASSWORD = "mysql123456";
  /**
   * mysql驱动程序
   */
  private static final String ORACLEDRIVER = "com.mysql.jdbc.Driver";

  /**
   * 启动程序
   */
  public static void main(String[] args) {
    Connection con = null;
    PreparedStatement pre = null;
    ResultSet result = null;
    try {
      Class.forName(ORACLEDRIVER);
      con = DriverManager.getConnection(URL, USER, PASSWORD);
      System.out.println("连接成功！");

      String sql = "select * from nideshop_user";
      pre = con.prepareStatement(sql);
      result = pre.executeQuery();//执行查询

      while (result.next()) {
        // 当结果集不为空时
        String username = result.getString("username");
        String mobile = result.getString("mobile");
        System.out.println("会员：" + username + "；手机号：" + mobile);
      }
    } catch (ClassNotFoundException e) {
      //数据库驱动类异常处理
      System.out.println("Sorry,can`t find the Driver!");
      e.printStackTrace();
    } catch (SQLException e) {
      //数据库连接失败异常处理
      e.printStackTrace();
    } catch (Exception e) {
      // TODO: handle exception
      e.printStackTrace();
    } finally {
      try {
        if (result != null) {
          result.close();
        }
        if (pre != null) {
          pre.close();
        }
        if (con != null) {
          con.close();
        }
        System.out.println("数据库连接已关闭！");
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
}
